package com.techysky.repository;

import java.io.Serializable;
import java.util.List;

import org.springframework.data.jpa.repository.Query;

import com.techysky.entity.ExamRecord;

public interface ExamRecordRepository extends CoreRepository<ExamRecord, Serializable> {
	@Query(value="select score from sys_exam_record e where e.paper_id=?1 and e.user_id=?2  ",nativeQuery=true)
	Float findScoreByPaperIdAndUserId(String paperId, String id);
	
	List<ExamRecord> findByUserId(String id);
}